﻿-- =========================================================================================================
-- Author:		MICHAEL RITACCO
-- Copyright:	2010 MEKHANO GROUP LLC
-- Version:		08/21/2010 1.0
-- =========================================================================================================
CREATE PROCEDURE [flcr].[api_domain_sel_lov]
	@DOMAIN_ID INT = NULL
AS
BEGIN
  
	SELECT	A.[DOMAIN_NAME]
	  FROM	[flcr].[DOMAIN] A
	 WHERE	A.[DOMAIN_ID] = COALESCE(@DOMAIN_ID, A.[DOMAIN_ID])  

END